﻿/****** Object:  Table [dbo].[Employees]    Script Date: 03/09/2010 12:40:54 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Employees]') AND type in (N'U'))
/****** Object:  Table [dbo].[Employees]    Script Date: 03/09/2010 12:40:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Employees]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Employees](
	[EmployeeID] [int] IDENTITY(1,1) NOT NULL,
	[FirstName] [varchar](50) NULL,
	[LastName] [varchar](50) NULL,
	[ContactNo] [bigint] NULL,
	[Address] [nvarchar](200) NULL
)
END
GO
SET IDENTITY_INSERT [dbo].[Employees] ON
INSERT [dbo].[Employees] ([EmployeeID], [FirstName], [LastName], [ContactNo], [Address]) VALUES (1, N'Rajiv', N'Popat', 9923456778, N'Kolkata')
INSERT [dbo].[Employees] ([EmployeeID], [FirstName], [LastName], [ContactNo], [Address]) VALUES (2, N'Anshuman', N'Srivastava', 9830456789, N'Asansol,WB')
INSERT [dbo].[Employees] ([EmployeeID], [FirstName], [LastName], [ContactNo], [Address]) VALUES (3, N'Esha', N'Patra', 9830005678, N'Ruby')
INSERT [dbo].[Employees] ([EmployeeID], [FirstName], [LastName], [ContactNo], [Address]) VALUES (4, N'Koushik', N'Das', 9830445678, N'Garia')
INSERT [dbo].[Employees] ([EmployeeID], [FirstName], [LastName], [ContactNo], [Address]) VALUES (5, N'Subhojit', N'Tarafdar', 9987654632, N'Patuli')
SET IDENTITY_INSERT [dbo].[Employees] OFF
 